using System; 
using System.Text; 
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration; 
using System.Xml; 
using System.Xml.Serialization;
using SubSonic; 
using SubSonic.Utilities;

namespace Commerce.Common{
    public partial class SPs{
        
        /// <summary>
        /// Creates an object wrapper for the AddCategory Procedure
        /// </summary>
        public static StoredProcedure AddCategory(string CategoryName, int? LogID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("AddCategory" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@CategoryName", CategoryName,DbType.String);
        	
            sp.Command.AddParameter("@LogID", LogID,DbType.Int32);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Coupons_GetCoupon Procedure
        /// </summary>
        public static StoredProcedure CouponsGetCoupon(string couponCode)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Coupons_GetCoupon" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@couponCode", couponCode,DbType.String);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Coupons_GetCouponType Procedure
        /// </summary>
        public static StoredProcedure CouponsGetCouponType(int? couponTypeId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Coupons_GetCouponType" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@couponTypeId", couponTypeId,DbType.Int32);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Coupons_SaveCoupon Procedure
        /// </summary>
        public static StoredProcedure CouponsSaveCoupon(string CouponCode, int? CouponTypeId, bool? IsSingleUse, int? NumberUses, DateTime? ExpirationDate, string XmlData)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Coupons_SaveCoupon" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@CouponCode", CouponCode,DbType.String);
        	
            sp.Command.AddParameter("@CouponTypeId", CouponTypeId,DbType.Int32);
        	
            sp.Command.AddParameter("@IsSingleUse", IsSingleUse,DbType.Boolean);
        	
            sp.Command.AddParameter("@NumberUses", NumberUses,DbType.Int32);
        	
            sp.Command.AddParameter("@ExpirationDate", ExpirationDate,DbType.DateTime);
        	
            sp.Command.AddParameter("@XmlData", XmlData,DbType.String);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Coupons_SaveCouponType Procedure
        /// </summary>
        public static StoredProcedure CouponsSaveCouponType(int? CouponTypeId, string Description, string ProcessingClassName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Coupons_SaveCouponType" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@CouponTypeId", CouponTypeId,DbType.Int32);
        	
            sp.Command.AddParameter("@Description", Description,DbType.String);
        	
            sp.Command.AddParameter("@ProcessingClassName", ProcessingClassName,DbType.String);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Promo_AddProduct Procedure
        /// </summary>
        public static StoredProcedure PromoAddProduct(int? promoID, int? productID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Promo_AddProduct" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@promoID", promoID,DbType.Int32);
        	
            sp.Command.AddParameter("@productID", productID,DbType.Int32);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Promo_Bundle_AddProduct Procedure
        /// </summary>
        public static StoredProcedure PromoBundleAddProduct(int? bundleID, int? productID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Promo_Bundle_AddProduct" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@bundleID", bundleID,DbType.Int32);
        	
            sp.Command.AddParameter("@productID", productID,DbType.Int32);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Promo_Bundle_GetAvailableProducts Procedure
        /// </summary>
        public static StoredProcedure PromoBundleGetAvailableProducts(int? bundleID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Promo_Bundle_GetAvailableProducts" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@bundleID", bundleID,DbType.Int32);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Promo_Bundle_GetByProductID Procedure
        /// </summary>
        public static StoredProcedure PromoBundleGetByProductID(int? productID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Promo_Bundle_GetByProductID" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@productID", productID,DbType.Int32);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Promo_Bundle_GetSelectedProducts Procedure
        /// </summary>
        public static StoredProcedure PromoBundleGetSelectedProducts(int? bundleID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Promo_Bundle_GetSelectedProducts" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@bundleID", bundleID,DbType.Int32);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Promo_EnsureOrderCoupon Procedure
        /// </summary>
        public static StoredProcedure PromoEnsureOrderCoupon(int? orderID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Promo_EnsureOrderCoupon" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@orderID", orderID,DbType.Int32);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Promo_GetProductList Procedure
        /// </summary>
        public static StoredProcedure PromoGetProductList(int? promoID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Promo_GetProductList" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@promoID", promoID,DbType.Int32);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Promo_ProductMatrix Procedure
        /// </summary>
        public static StoredProcedure PromoProductMatrix()
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Promo_ProductMatrix" , DataService.GetInstance("dashCommerce"),"");
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Promo_RemoveProducts Procedure
        /// </summary>
        public static StoredProcedure PromoRemoveProducts(int? promoID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Promo_RemoveProducts" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@promoID", promoID,DbType.Int32);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Shipping_GetRates Procedure
        /// </summary>
        public static StoredProcedure ShippingGetRates(decimal? weight)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Shipping_GetRates" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@weight", weight,DbType.Currency);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Shipping_GetRates_Air Procedure
        /// </summary>
        public static StoredProcedure ShippingGetRatesAir(decimal? weight)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Shipping_GetRates_Air" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@weight", weight,DbType.Currency);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Shipping_GetRates_Ground Procedure
        /// </summary>
        public static StoredProcedure ShippingGetRatesGround(decimal? weight)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Shipping_GetRates_Ground" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@weight", weight,DbType.Currency);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Stats_FavoriteCategories Procedure
        /// </summary>
        public static StoredProcedure StatsFavoriteCategories(string userName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Stats_FavoriteCategories" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@userName", userName,DbType.String);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Stats_FavoriteProducts Procedure
        /// </summary>
        public static StoredProcedure StatsFavoriteProducts(string userName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Stats_FavoriteProducts" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@userName", userName,DbType.String);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Stats_Tracker_GetByBehaviorID Procedure
        /// </summary>
        public static StoredProcedure StatsTrackerGetByBehaviorID(int? behaviorID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Stats_Tracker_GetByBehaviorID" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@behaviorID", behaviorID,DbType.Int32);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Stats_Tracker_GetByProductAndBehavior Procedure
        /// </summary>
        public static StoredProcedure StatsTrackerGetByProductAndBehavior(int? behaviorID, string sku)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Stats_Tracker_GetByProductAndBehavior" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@behaviorID", behaviorID,DbType.Int32);
        	
            sp.Command.AddParameter("@sku", sku,DbType.String);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Stats_Tracker_SynchTrackingCookie Procedure
        /// </summary>
        public static StoredProcedure StatsTrackerSynchTrackingCookie(string userName, string trackerCookie)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Stats_Tracker_SynchTrackingCookie" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@userName", userName,DbType.String);
        	
            sp.Command.AddParameter("@trackerCookie", trackerCookie,DbType.String);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_AddItemToCart Procedure
        /// </summary>
        public static StoredProcedure StoreAddItemToCart(string userName, int? productID, string attributes, decimal? pricePaid, string promoCode, int? quantity)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_AddItemToCart" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@userName", userName,DbType.String);
        	
            sp.Command.AddParameter("@productID", productID,DbType.Int32);
        	
            sp.Command.AddParameter("@attributes", attributes,DbType.String);
        	
            sp.Command.AddParameter("@pricePaid", pricePaid,DbType.Currency);
        	
            sp.Command.AddParameter("@promoCode", promoCode,DbType.String);
        	
            sp.Command.AddParameter("@quantity", quantity,DbType.Int32);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Category_GetAllSubs Procedure
        /// </summary>
        public static StoredProcedure StoreCategoryGetAllSubs(int? parentID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Category_GetAllSubs" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@parentID", parentID,DbType.Int32);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Category_GetByProductID Procedure
        /// </summary>
        public static StoredProcedure StoreCategoryGetByProductID(int? productID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Category_GetByProductID" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@productID", productID,DbType.Int32);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Category_GetCrumbs Procedure
        /// </summary>
        public static StoredProcedure StoreCategoryGetCrumbs(int? categoryID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Category_GetCrumbs" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@categoryID", categoryID,DbType.Int32);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Category_GetPageByGUIDMulti Procedure
        /// </summary>
        public static StoredProcedure StoreCategoryGetPageByGUIDMulti(string categoryGUID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Category_GetPageByGUIDMulti" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@categoryGUID", categoryGUID,DbType.String);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Category_GetPageByNameMulti Procedure
        /// </summary>
        public static StoredProcedure StoreCategoryGetPageByNameMulti(string categoryName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Category_GetPageByNameMulti" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@categoryName", categoryName,DbType.String);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Category_GetPageMulti Procedure
        /// </summary>
        public static StoredProcedure StoreCategoryGetPageMulti(int? categoryID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Category_GetPageMulti" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@categoryID", categoryID,DbType.Int32);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Order_Query Procedure
        /// </summary>
        public static StoredProcedure StoreOrderQuery(DateTime? dateStart, DateTime? dateEnd, string userName, string orderNumber)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Order_Query" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@dateStart", dateStart,DbType.DateTime);
        	
            sp.Command.AddParameter("@dateEnd", dateEnd,DbType.DateTime);
        	
            sp.Command.AddParameter("@userName", userName,DbType.String);
        	
            sp.Command.AddParameter("@orderNumber", orderNumber,DbType.String);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Product_AddRating Procedure
        /// </summary>
        public static StoredProcedure StoreProductAddRating(int? productID, int? rating, string userName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Product_AddRating" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@productID", productID,DbType.Int32);
        	
            sp.Command.AddParameter("@rating", rating,DbType.Int32);
        	
            sp.Command.AddParameter("@userName", userName,DbType.String);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Product_DeletePermanent Procedure
        /// </summary>
        public static StoredProcedure StoreProductDeletePermanent(int? productID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Product_DeletePermanent" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@productID", productID,DbType.Int32);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Product_GetByCategoryID Procedure
        /// </summary>
        public static StoredProcedure StoreProductGetByCategoryID(int? categoryID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Product_GetByCategoryID" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@categoryID", categoryID,DbType.Int32);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Product_GetByManufacturerID Procedure
        /// </summary>
        public static StoredProcedure StoreProductGetByManufacturerID(int? manufacturerID, int? categoryID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Product_GetByManufacturerID" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@manufacturerID", manufacturerID,DbType.Int32);
        	
            sp.Command.AddParameter("@categoryID", categoryID,DbType.Int32);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Product_GetByPriceRange Procedure
        /// </summary>
        public static StoredProcedure StoreProductGetByPriceRange(int? categoryID, decimal? priceStart, decimal? priceEnd)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Product_GetByPriceRange" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@categoryID", categoryID,DbType.Int32);
        	
            sp.Command.AddParameter("@priceStart", priceStart,DbType.Currency);
        	
            sp.Command.AddParameter("@priceEnd", priceEnd,DbType.Currency);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Product_GetMostPopular Procedure
        /// </summary>
        public static StoredProcedure StoreProductGetMostPopular()
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Product_GetMostPopular" , DataService.GetInstance("dashCommerce"),"");
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Product_GetPostAddMulti Procedure
        /// </summary>
        public static StoredProcedure StoreProductGetPostAddMulti(string userName)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Product_GetPostAddMulti" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@userName", userName,DbType.String);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Product_SmartSearch Procedure
        /// </summary>
        public static StoredProcedure StoreProductSmartSearch(int? DescriptionLength, bool? AllWords, string Word1, string Word2, string Word3, string Word4, string Word5)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Product_SmartSearch" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@DescriptionLength", DescriptionLength,DbType.Int32);
        	
            sp.Command.AddParameter("@AllWords", AllWords,DbType.Boolean);
        	
            sp.Command.AddParameter("@Word1", Word1,DbType.String);
        	
            sp.Command.AddParameter("@Word2", Word2,DbType.String);
        	
            sp.Command.AddParameter("@Word3", Word3,DbType.String);
        	
            sp.Command.AddParameter("@Word4", Word4,DbType.String);
        	
            sp.Command.AddParameter("@Word5", Word5,DbType.String);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the CSK_Tax_GetTaxRate Procedure
        /// </summary>
        public static StoredProcedure TaxGetTaxRate(string zip)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Tax_GetTaxRate" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@zip", zip,DbType.String);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the ClearLogs Procedure
        /// </summary>
        public static StoredProcedure ClearLogs()
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("ClearLogs" , DataService.GetInstance("dashCommerce"),"");
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the InsertCategoryLog Procedure
        /// </summary>
        public static StoredProcedure InsertCategoryLog(int? CategoryID, int? LogID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("InsertCategoryLog" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@CategoryID", CategoryID,DbType.Int32);
        	
            sp.Command.AddParameter("@LogID", LogID,DbType.Int32);
        	
            return sp;
        }

        
        /// <summary>
        /// Creates an object wrapper for the WriteLog Procedure
        /// </summary>
        public static StoredProcedure WriteLog(int? EventID, int? Priority, string Severity, string Title, DateTime? Timestamp, string MachineName, string AppDomainName, string ProcessID, string ProcessName, string ThreadName, string Win32ThreadId, string Message, string FormattedMessage, int? LogId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("WriteLog" , DataService.GetInstance("dashCommerce"),"dbo");
        	
            sp.Command.AddParameter("@EventID", EventID,DbType.Int32);
        	
            sp.Command.AddParameter("@Priority", Priority,DbType.Int32);
        	
            sp.Command.AddParameter("@Severity", Severity,DbType.String);
        	
            sp.Command.AddParameter("@Title", Title,DbType.String);
        	
            sp.Command.AddParameter("@Timestamp", Timestamp,DbType.DateTime);
        	
            sp.Command.AddParameter("@MachineName", MachineName,DbType.String);
        	
            sp.Command.AddParameter("@AppDomainName", AppDomainName,DbType.String);
        	
            sp.Command.AddParameter("@ProcessID", ProcessID,DbType.String);
        	
            sp.Command.AddParameter("@ProcessName", ProcessName,DbType.String);
        	
            sp.Command.AddParameter("@ThreadName", ThreadName,DbType.String);
        	
            sp.Command.AddParameter("@Win32ThreadId", Win32ThreadId,DbType.String);
        	
            sp.Command.AddParameter("@Message", Message,DbType.String);
        	
            sp.Command.AddParameter("@FormattedMessage", FormattedMessage,DbType.String);
        	
            sp.Command.AddOutputParameter("@LogId", DbType.Int32);
            
            return sp;
        }

        
    }

    
}

